Performance Guidelines for Dining Table List
In this article
In the dining table list layout, managed by the Table List Startup POS, you use a POS data table to select what information to show for the dining table list. The source table is the Dining Table Status table. This POS data table is assigned to the grid control #HOSP-TABLELIST-GRID.
Required Field
The Dining Table No. field (no. 3) is required in this POS data table. The Key Value Field 1 should be 3 and the field should not be shown in the list (keep it at the bottom and let Table Columns for the data table not include this field).
Optional Fields
Optional fields show the caption of the table, status, general information and alert text
Before version 26., it was necessary to use source expressions in this POS data table instead of fields from the Dining Table Status table. These source expressions slow down grid loading considerably.
Starting from version 26., if the POS data table does not include source expressions, an optimized process is used to populate the grid, resulting in much faster loading times.
POS Data Table with Source Expressions causing slow grid performance
The POS data table for the dining table list, can be using up to five source expressions. These source expressions slow down grid loading considerably.
| Column Caption | Source Expression (no field number) |
| Caption | HO-TRCAP |
| Status | HO-TRSTAT |
|
Info |
HO-TRINFO |
| Alert Text | HO-TRALERT |
| Alert Mark | HO-TRALERMA |
POS Data Table with fields from the source table improving performance
To improve performance it is necessary to use fields from the Dining Table Status table directly instead of source expressions. These fields show the same information as the corresponding source expressions for the POS data table:
| Column Caption | Field No. | Field Name |
| Caption | 120 | Caption Text |
| Status | 126 | Table Status Text |
|
Info |
102 | Button Guest Text |
| Alert Text | 111 | Pop-up Alert Text |
| Alert Mark | 125 | Active Alert |
Note: The POS data table also needs to be marked as Temporary.